package com.orange.handler;

import java.sql.SQLException;
import java.util.List;
import java.util.Map;

import com.orange.dbhelp.page.Page;
import com.orange.modules.bean.SchoolContactsBean;
import com.orange.modules.entity.school.AuthSchoolContacts;

public interface AuthSchoolContactService {

	/**
	 * 查询联系人信息
	 * @param pid
	 * @return
	 * @throws SQLException
	 */
	public AuthSchoolContacts queryAuthSchoolContactsBypid(String pid) throws SQLException;
	
	/**
	 * 分页显示联系人信息
	 * @param pageNumber
	 * @param pageSize
	 * @param map
	 * @return
	 * @throws SQLException
	 */
	public Page<AuthSchoolContacts> queryAuthSchoolContactsByPage(Integer pageNumber,Integer pageSize , Map<String ,String> map) throws SQLException;
	
	/**
	 * 删除指定的联系人
	 */
	public void deleteAuthSchoolContactsBypid(String pid) throws SQLException;
	
	/**
	 * 增加指定学校的联系人信息
	 */
	public void insertAuthSchoolContacts(AuthSchoolContacts ac) throws SQLException;
	
	/**
	 * 修改指定的联系人信息
	 */
	public void updateAuthSchoolContacts(AuthSchoolContacts as) throws SQLException;
	
	/**
	 *  根据学校id查询联系人信息
	 */
	public AuthSchoolContacts queryAuthSchoolContactsBySchoolId(String account) throws SQLException;
	
	/**
	 * 根据type,查询联系人信息
	 */
	public Page<AuthSchoolContacts> queryAuthContactsBytype(Integer pageNumber,Integer pageSize , Map<String ,String> map) throws SQLException;
		
	/**
	 * 联系人和学校
	 */
	public Page<SchoolContactsBean> queryAuthSchoolContactsBySchool(Integer pageNumber,Integer pageSize , Map<String ,String> map) throws SQLException;


	/**
	 * 
	 */
	public Page<SchoolContactsBean> queryAuthSchoolContactsByPage1(Integer pageNumber,Integer pageSize , Map<String ,String> map) throws SQLException;

	/**
	 * 分页显示联系人信息
	 */
	public Page<AuthSchoolContacts> queryAuthSchoolContactsByPage2(Integer pageNumber,Integer pageSize , String schoolId, String type) throws SQLException;


	/**
	 * 根据学校查询教科院负责人信息
	 * @throws SQLException 
	 */
	public List<AuthSchoolContacts> queryType1BySchool(String schoolId) throws SQLException;
		
	/**
	 * 根据学校查询教务处负责人信息
	 * @throws SQLException 
	 */
	public List<AuthSchoolContacts> queryType2BySchool(String schoolId) throws SQLException;
}
